Dataset statistics
| Number of variables | 37 |
|---|---|
| Number of observations | 109 |
| Missing cells | 0 |
| Missing cells (%) | 0.0% |
| Duplicate rows | 0 |
| Duplicate rows (%) | 0.0% |
| Total size in memory | 15.2 KiB |
| Average record size in memory | 143.2 B |
Variable types
| BOOL | 24 |
|---|---|
| NUM | 11 |
| DATE | 1 |
| CAT | 1 |
Reproduction
| Analysis started | 2020-08-17 20:11:14.773675 |
|---|---|
| Analysis finished | 2020-08-17 20:12:13.192950 |
| Duration | 58.42 seconds |
| Version | pandas-profiling v2.8.0 |
| Command line | pandas_profiling --config_file config.yaml [YOUR_FILE.csv] |
| Download configuration | config.yaml |
# Drops has constant value "1" | Constant |
Offer ID1 has constant value "4915" | Constant |
Remaining Budget has constant value "0" | Constant |
Name_First Access Solid B has constant value "1" | Constant |
Offer Name1_First Access Solid Black Visa Credit Card - Display - Lead Submit - W4 (e-mail) has constant value "1" | Constant |
Operational Status1_Live has constant value "1" | Constant |
Payout Type1_1st PAGE SUBMIT has constant value "1" | Constant |
Opens is highly correlated with Delivered | High correlation |
Delivered is highly correlated with Opens | High correlation |
Data Provider (group)_Venice is highly correlated with Data Provider (group)_Irvine | High correlation |
Data Provider (group)_Irvine is highly correlated with Data Provider (group)_Venice | High correlation |
Delivered has unique values | Unique |
eCPM has 5 (4.6%) zeros | Zeros |
EPC has 5 (4.6%) zeros | Zeros |
CLR has 33 (30.3%) zeros | Zeros |
Revenue has 5 (4.6%) zeros | Zeros |
Affiliate ID1
Real number (ℝ≥0)
| Distinct count | 34 |
|---|---|
| Unique (%) | 31.2% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 460599.7706422018 |
|---|---|
| Minimum | 460121 |
| Maximum | 460828 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Memory size | 872.0 B |
Quantile statistics
| Minimum | 460121 |
|---|---|
| 5-th percentile | 460351 |
| Q1 | 460454 |
| median | 460628 |
| Q3 | 460744 |
| 95-th percentile | 460809 |
| Maximum | 460828 |
| Range | 707 |
| Interquartile range (IQR) | 290 |
Descriptive statistics
| Standard deviation | 163.4923621 |
|---|---|
| Coefficient of variation (CV) | 0.0003549553702 |
| Kurtosis | -0.5038418059 |
| Mean | 460599.7706 |
| Median Absolute Deviation (MAD) | 145 |
| Skewness | -0.4711826948 |
| Sum | 50205375 |
| Variance | 26729.75246 |
| Value | Count | Frequency (%) | |
| 460809 | 8 | 7.3% | |
| 460639 | 7 | 6.4% | |
| 460804 | 6 | 5.5% | |
| 460467 | 6 | 5.5% | |
| 460587 | 5 | 4.6% | |
| 460628 | 5 | 4.6% | |
| 460451 | 5 | 4.6% | |
| 460661 | 5 | 4.6% | |
| 460398 | 5 | 4.6% | |
| 460443 | 4 | 3.7% | |
| Other values (24) | 53 | 48.6% |
| Value | Count | Frequency (%) | |
| 460121 | 1 | 0.9% | |
| 460218 | 2 | 1.8% | |
| 460297 | 1 | 0.9% | |
| 460351 | 3 | 2.8% | |
| 460379 | 4 | 3.7% |
| Value | Count | Frequency (%) | |
| 460828 | 4 | 3.7% | |
| 460809 | 8 | 7.3% | |
| 460804 | 6 | 5.5% | |
| 460767 | 4 | 3.7% | |
| 460766 | 1 | 0.9% |
| Distinct count | 96 |
|---|---|
| Unique (%) | 88.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 4.150550458715596 |
|---|---|
| Minimum | 0.0 |
| Maximum | 21.9 |
| Zeros | 5 |
| Zeros (%) | 4.6% |
| Memory size | 872.0 B |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0.236 |
| Q1 | 1.62 |
| median | 3.74 |
| Q3 | 5.54 |
| 95-th percentile | 11.006 |
| Maximum | 21.9 |
| Range | 21.9 |
| Interquartile range (IQR) | 3.92 |
Descriptive statistics
| Standard deviation | 3.496684365 |
|---|---|
| Coefficient of variation (CV) | 0.8424628009 |
| Kurtosis | 5.318753487 |
| Mean | 4.150550459 |
| Median Absolute Deviation (MAD) | 1.99 |
| Skewness | 1.769663976 |
| Sum | 452.41 |
| Variance | 12.22680155 |
| Value | Count | Frequency (%) | |
| 0 | 5 | 4.6% | |
| 3.82 | 3 | 2.8% | |
| 1.17 | 3 | 2.8% | |
| 1.18 | 2 | 1.8% | |
| 4.23 | 2 | 1.8% | |
| 1.98 | 2 | 1.8% | |
| 2.29 | 2 | 1.8% | |
| 1.56 | 2 | 1.8% | |
| 6.95 | 1 | 0.9% | |
| 1.64 | 1 | 0.9% | |
| Other values (86) | 86 | 78.9% |
| Value | Count | Frequency (%) | |
| 0 | 5 | 4.6% | |
| 0.22 | 1 | 0.9% | |
| 0.26 | 1 | 0.9% | |
| 0.34 | 1 | 0.9% | |
| 0.4 | 1 | 0.9% |
| Value | Count | Frequency (%) | |
| 21.9 | 1 | 0.9% | |
| 12.58 | 1 | 0.9% | |
| 12.01 | 1 | 0.9% | |
| 11.76 | 1 | 0.9% | |
| 11.41 | 1 | 0.9% |
CTR
Real number (ℝ≥0)
| Distinct count | 93 |
|---|---|
| Unique (%) | 85.3% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 0.014433944954128438 |
|---|---|
| Minimum | 0.001 |
| Maximum | 0.0534 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Memory size | 872.0 B |
Quantile statistics
| Minimum | 0.001 |
|---|---|
| 5-th percentile | 0.00272 |
| Q1 | 0.0082 |
| median | 0.0128 |
| Q3 | 0.0185 |
| 95-th percentile | 0.03044 |
| Maximum | 0.0534 |
| Range | 0.0524 |
| Interquartile range (IQR) | 0.0103 |
Descriptive statistics
| Standard deviation | 0.009292771187 |
|---|---|
| Coefficient of variation (CV) | 0.6438136779 |
| Kurtosis | 3.291188583 |
| Mean | 0.01443394495 |
| Median Absolute Deviation (MAD) | 0.0052 |
| Skewness | 1.474736473 |
| Sum | 1.5733 |
| Variance | 8.635559633e-05 |
| Value | Count | Frequency (%) | |
| 0.0108 | 4 | 3.7% | |
| 0.0089 | 3 | 2.8% | |
| 0.0232 | 2 | 1.8% | |
| 0.0086 | 2 | 1.8% | |
| 0.0097 | 2 | 1.8% | |
| 0.0135 | 2 | 1.8% | |
| 0.013 | 2 | 1.8% | |
| 0.0122 | 2 | 1.8% | |
| 0.0067 | 2 | 1.8% | |
| 0.0147 | 2 | 1.8% | |
| Other values (83) | 86 | 78.9% |
| Value | Count | Frequency (%) | |
| 0.001 | 1 | 0.9% | |
| 0.0011 | 1 | 0.9% | |
| 0.0015 | 1 | 0.9% | |
| 0.0017 | 1 | 0.9% | |
| 0.002 | 1 | 0.9% |
| Value | Count | Frequency (%) | |
| 0.0534 | 1 | 0.9% | |
| 0.0456 | 1 | 0.9% | |
| 0.0413 | 1 | 0.9% | |
| 0.0394 | 1 | 0.9% | |
| 0.0329 | 1 | 0.9% |
| Distinct count | 47 |
|---|---|
| Unique (%) | 43.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 0.27844036697247704 |
|---|---|
| Minimum | 0.0 |
| Maximum | 0.66 |
| Zeros | 5 |
| Zeros (%) | 4.6% |
| Memory size | 872.0 B |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0.052 |
| Q1 | 0.2 |
| median | 0.26 |
| Q3 | 0.36 |
| 95-th percentile | 0.52 |
| Maximum | 0.66 |
| Range | 0.66 |
| Interquartile range (IQR) | 0.16 |
Descriptive statistics
| Standard deviation | 0.1421017783 |
|---|---|
| Coefficient of variation (CV) | 0.5103490555 |
| Kurtosis | 0.1462308067 |
| Mean | 0.278440367 |
| Median Absolute Deviation (MAD) | 0.09 |
| Skewness | 0.3599414382 |
| Sum | 30.35 |
| Variance | 0.02019291539 |
| Value | Count | Frequency (%) | |
| 0.21 | 7 | 6.4% | |
| 0.32 | 6 | 5.5% | |
| 0.23 | 6 | 5.5% | |
| 0.41 | 5 | 4.6% | |
| 0.24 | 5 | 4.6% | |
| 0 | 5 | 4.6% | |
| 0.2 | 4 | 3.7% | |
| 0.14 | 4 | 3.7% | |
| 0.47 | 4 | 3.7% | |
| 0.28 | 4 | 3.7% | |
| Other values (37) | 59 | 54.1% |
| Value | Count | Frequency (%) | |
| 0 | 5 | 4.6% | |
| 0.04 | 1 | 0.9% | |
| 0.07 | 1 | 0.9% | |
| 0.08 | 1 | 0.9% | |
| 0.09 | 1 | 0.9% |
| Value | Count | Frequency (%) | |
| 0.66 | 1 | 0.9% | |
| 0.65 | 1 | 0.9% | |
| 0.64 | 1 | 0.9% | |
| 0.57 | 1 | 0.9% | |
| 0.53 | 1 | 0.9% |
| Distinct count | 54 |
|---|---|
| Unique (%) | 49.5% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 0.006869724770642201 |
|---|---|
| Minimum | 0.0 |
| Maximum | 0.0856 |
| Zeros | 33 |
| Zeros (%) | 30.3% |
| Memory size | 872.0 B |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 0.0031 |
| Q3 | 0.0064 |
| 95-th percentile | 0.0157 |
| Maximum | 0.0856 |
| Range | 0.0856 |
| Interquartile range (IQR) | 0.0064 |
Descriptive statistics
| Standard deviation | 0.01495860649 |
|---|---|
| Coefficient of variation (CV) | 2.177468093 |
| Kurtosis | 17.61872601 |
| Mean | 0.006869724771 |
| Median Absolute Deviation (MAD) | 0.0031 |
| Skewness | 4.191017426 |
| Sum | 0.7488 |
| Variance | 0.0002237599083 |
| Value | Count | Frequency (%) | |
| 0 | 33 | 30.3% | |
| 0.0025 | 4 | 3.7% | |
| 0.0019 | 3 | 2.8% | |
| 0.0117 | 3 | 2.8% | |
| 0.0053 | 3 | 2.8% | |
| 0.0056 | 3 | 2.8% | |
| 0.0031 | 2 | 1.8% | |
| 0.0033 | 2 | 1.8% | |
| 0.0064 | 2 | 1.8% | |
| 0.0063 | 2 | 1.8% | |
| Other values (44) | 52 | 47.7% |
| Value | Count | Frequency (%) | |
| 0 | 33 | 30.3% | |
| 0.0006 | 1 | 0.9% | |
| 0.0014 | 1 | 0.9% | |
| 0.0015 | 1 | 0.9% | |
| 0.0016 | 2 | 1.8% |
| Value | Count | Frequency (%) | |
| 0.0856 | 1 | 0.9% | |
| 0.0818 | 1 | 0.9% | |
| 0.0756 | 1 | 0.9% | |
| 0.0589 | 1 | 0.9% | |
| 0.0568 | 1 | 0.9% |
| Distinct count | 1 |
|---|---|
| Unique (%) | 0.9% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 872.0 B |
| 1 |
|---|
| Value | Count | Frequency (%) | |
| 1 | 109 | 100.0% |
Click Rate
Real number (ℝ≥0)
| Distinct count | 92 |
|---|---|
| Unique (%) | 84.4% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 0.10691467889908259 |
|---|---|
| Minimum | 0.027 |
| Maximum | 0.281 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Memory size | 872.0 B |
Quantile statistics
| Minimum | 0.027 |
|---|---|
| 5-th percentile | 0.04504 |
| Q1 | 0.0801 |
| median | 0.1012 |
| Q3 | 0.1278 |
| 95-th percentile | 0.1908 |
| Maximum | 0.281 |
| Range | 0.254 |
| Interquartile range (IQR) | 0.0477 |
Descriptive statistics
| Standard deviation | 0.04607362631 |
|---|---|
| Coefficient of variation (CV) | 0.4309382658 |
| Kurtosis | 2.01640169 |
| Mean | 0.1069146789 |
| Median Absolute Deviation (MAD) | 0.0248 |
| Skewness | 1.150918925 |
| Sum | 11.6537 |
| Variance | 0.002122779042 |
| Value | Count | Frequency (%) | |
| 0.109 | 3 | 2.8% | |
| 0.095 | 3 | 2.8% | |
| 0.087 | 3 | 2.8% | |
| 0.067 | 2 | 1.8% | |
| 0.111 | 2 | 1.8% | |
| 0.075 | 2 | 1.8% | |
| 0.082 | 2 | 1.8% | |
| 0.084 | 2 | 1.8% | |
| 0.121 | 2 | 1.8% | |
| 0.108 | 2 | 1.8% | |
| Other values (82) | 86 | 78.9% |
| Value | Count | Frequency (%) | |
| 0.027 | 1 | 0.9% | |
| 0.028 | 1 | 0.9% | |
| 0.043 | 1 | 0.9% | |
| 0.044 | 1 | 0.9% | |
| 0.045 | 2 | 1.8% |
| Value | Count | Frequency (%) | |
| 0.281 | 1 | 0.9% | |
| 0.247 | 1 | 0.9% | |
| 0.234 | 1 | 0.9% | |
| 0.223 | 1 | 0.9% | |
| 0.2121 | 1 | 0.9% |
Clicks
Real number (ℝ≥0)
| Distinct count | 105 |
|---|---|
| Unique (%) | 96.3% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 597.5045871559633 |
|---|---|
| Minimum | 42 |
| Maximum | 3621 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Memory size | 872.0 B |
Quantile statistics
| Minimum | 42 |
|---|---|
| 5-th percentile | 116 |
| Q1 | 283 |
| median | 476 |
| Q3 | 759 |
| 95-th percentile | 1570 |
| Maximum | 3621 |
| Range | 3579 |
| Interquartile range (IQR) | 476 |
Descriptive statistics
| Standard deviation | 505.6823154 |
|---|---|
| Coefficient of variation (CV) | 0.8463237376 |
| Kurtosis | 11.48771409 |
| Mean | 597.5045872 |
| Median Absolute Deviation (MAD) | 225 |
| Skewness | 2.667603589 |
| Sum | 65128 |
| Variance | 255714.6041 |
| Value | Count | Frequency (%) | |
| 183 | 2 | 1.8% | |
| 527 | 2 | 1.8% | |
| 730 | 2 | 1.8% | |
| 206 | 2 | 1.8% | |
| 1019 | 1 | 0.9% | |
| 847 | 1 | 0.9% | |
| 293 | 1 | 0.9% | |
| 566 | 1 | 0.9% | |
| 827 | 1 | 0.9% | |
| 319 | 1 | 0.9% | |
| Other values (95) | 95 | 87.2% |
| Value | Count | Frequency (%) | |
| 42 | 1 | 0.9% | |
| 74 | 1 | 0.9% | |
| 83 | 1 | 0.9% | |
| 108 | 1 | 0.9% | |
| 109 | 1 | 0.9% |
| Value | Count | Frequency (%) | |
| 3621 | 1 | 0.9% | |
| 1971 | 1 | 0.9% | |
| 1836 | 1 | 0.9% | |
| 1827 | 1 | 0.9% | |
| 1721 | 1 | 0.9% |
Date1
Date
| Distinct count | 52 |
|---|---|
| Unique (%) | 47.7% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 872.0 B |
| Minimum | 2020-01-31 00:00:00 |
|---|---|
| Maximum | 2020-04-12 00:00:00 |
| Distinct count | 109 |
|---|---|
| Unique (%) | 100.0% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 52829.5871559633 |
|---|---|
| Minimum | 6812 |
| Maximum | 688381 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Memory size | 872.0 B |
Quantile statistics
| Minimum | 6812 |
|---|---|
| 5-th percentile | 14246.6 |
| Q1 | 26151 |
| median | 38125 |
| Q3 | 60720 |
| 95-th percentile | 150529.4 |
| Maximum | 688381 |
| Range | 681569 |
| Interquartile range (IQR) | 34569 |
Descriptive statistics
| Standard deviation | 69998.11759 |
|---|---|
| Coefficient of variation (CV) | 1.324979455 |
| Kurtosis | 63.72661776 |
| Mean | 52829.58716 |
| Median Absolute Deviation (MAD) | 16312 |
| Skewness | 7.20160629 |
| Sum | 5758425 |
| Variance | 4899736466 |
| Value | Count | Frequency (%) | |
| 688381 | 1 | 0.9% | |
| 42171 | 1 | 0.9% | |
| 7848 | 1 | 0.9% | |
| 20287 | 1 | 0.9% | |
| 29511 | 1 | 0.9% | |
| 47178 | 1 | 0.9% | |
| 155453 | 1 | 0.9% | |
| 14157 | 1 | 0.9% | |
| 34639 | 1 | 0.9% | |
| 68432 | 1 | 0.9% | |
| Other values (99) | 99 | 90.8% |
| Value | Count | Frequency (%) | |
| 6812 | 1 | 0.9% | |
| 6864 | 1 | 0.9% | |
| 7401 | 1 | 0.9% | |
| 7848 | 1 | 0.9% | |
| 13970 | 1 | 0.9% |
| Value | Count | Frequency (%) | |
| 688381 | 1 | 0.9% | |
| 157408 | 1 | 0.9% | |
| 155453 | 1 | 0.9% | |
| 152206 | 1 | 0.9% | |
| 152147 | 1 | 0.9% |
| Distinct count | 1 |
|---|---|
| Unique (%) | 0.9% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 872.0 B |
| 4915 |
|---|
| Value | Count | Frequency (%) | |
| 4915 | 109 | 100.0% |
Length
| Max length | 4 |
|---|---|
| Median length | 4 |
| Mean length | 4 |
| Min length | 4 |
Open Rate
Real number (ℝ≥0)
| Distinct count | 94 |
|---|---|
| Unique (%) | 86.2% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 0.14038073394495412 |
|---|---|
| Minimum | 0.005 |
| Maximum | 0.342 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Memory size | 872.0 B |
Quantile statistics
| Minimum | 0.005 |
|---|---|
| 5-th percentile | 0.03296 |
| Q1 | 0.1019 |
| median | 0.135 |
| Q3 | 0.171 |
| 95-th percentile | 0.27524 |
| Maximum | 0.342 |
| Range | 0.337 |
| Interquartile range (IQR) | 0.0691 |
Descriptive statistics
| Standard deviation | 0.06770971739 |
|---|---|
| Coefficient of variation (CV) | 0.4823291308 |
| Kurtosis | 1.090895719 |
| Mean | 0.1403807339 |
| Median Absolute Deviation (MAD) | 0.034 |
| Skewness | 0.7135547855 |
| Sum | 15.3015 |
| Variance | 0.004584605829 |
| Value | Count | Frequency (%) | |
| 0.09 | 3 | 2.8% | |
| 0.131 | 3 | 2.8% | |
| 0.143 | 2 | 1.8% | |
| 0.153 | 2 | 1.8% | |
| 0.161 | 2 | 1.8% | |
| 0.219 | 2 | 1.8% | |
| 0.185 | 2 | 1.8% | |
| 0.164 | 2 | 1.8% | |
| 0.101 | 2 | 1.8% | |
| 0.085 | 2 | 1.8% | |
| Other values (84) | 87 | 79.8% |
| Value | Count | Frequency (%) | |
| 0.005 | 1 | 0.9% | |
| 0.007 | 2 | 1.8% | |
| 0.014 | 1 | 0.9% | |
| 0.015 | 1 | 0.9% | |
| 0.0326 | 1 | 0.9% |
| Value | Count | Frequency (%) | |
| 0.342 | 1 | 0.9% | |
| 0.327 | 1 | 0.9% | |
| 0.322 | 1 | 0.9% | |
| 0.313 | 1 | 0.9% | |
| 0.286 | 1 | 0.9% |
| Distinct count | 108 |
|---|---|
| Unique (%) | 99.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 7157.8899082568805 |
|---|---|
| Minimum | 631 |
| Maximum | 130167 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Memory size | 872.0 B |
Quantile statistics
| Minimum | 631 |
|---|---|
| 5-th percentile | 888.4 |
| Q1 | 2645 |
| median | 4719 |
| Q3 | 7604 |
| 95-th percentile | 18330.2 |
| Maximum | 130167 |
| Range | 129536 |
| Interquartile range (IQR) | 4959 |
Descriptive statistics
| Standard deviation | 12827.57427 |
|---|---|
| Coefficient of variation (CV) | 1.79208879 |
| Kurtosis | 79.76369562 |
| Mean | 7157.889908 |
| Median Absolute Deviation (MAD) | 2261 |
| Skewness | 8.360274 |
| Sum | 780210 |
| Variance | 164546661.6 |
| Value | Count | Frequency (%) | |
| 2310 | 2 | 1.8% | |
| 7934 | 1 | 0.9% | |
| 5807 | 1 | 0.9% | |
| 19175 | 1 | 0.9% | |
| 5455 | 1 | 0.9% | |
| 4689 | 1 | 0.9% | |
| 2130 | 1 | 0.9% | |
| 21588 | 1 | 0.9% | |
| 2645 | 1 | 0.9% | |
| 3670 | 1 | 0.9% | |
| Other values (98) | 98 | 89.9% |
| Value | Count | Frequency (%) | |
| 631 | 1 | 0.9% | |
| 713 | 1 | 0.9% | |
| 731 | 1 | 0.9% | |
| 741 | 1 | 0.9% | |
| 830 | 1 | 0.9% |
| Value | Count | Frequency (%) | |
| 130167 | 1 | 0.9% | |
| 21588 | 1 | 0.9% | |
| 21186 | 1 | 0.9% | |
| 19693 | 1 | 0.9% | |
| 19429 | 1 | 0.9% |
| Distinct count | 1 |
|---|---|
| Unique (%) | 0.9% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 872.0 B |
| 0 |
|---|
| Value | Count | Frequency (%) | |
| 0 | 109 | 100.0% |
| Distinct count | 29 |
|---|---|
| Unique (%) | 26.6% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 169.6880733944954 |
|---|---|
| Minimum | 0 |
| Maximum | 935 |
| Zeros | 5 |
| Zeros (%) | 4.6% |
| Memory size | 872.0 B |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 17 |
| Q1 | 68 |
| median | 119 |
| Q3 | 204 |
| 95-th percentile | 506.6 |
| Maximum | 935 |
| Range | 935 |
| Interquartile range (IQR) | 136 |
Descriptive statistics
| Standard deviation | 171.2543429 |
|---|---|
| Coefficient of variation (CV) | 1.009230286 |
| Kurtosis | 6.502105285 |
| Mean | 169.6880734 |
| Median Absolute Deviation (MAD) | 68 |
| Skewness | 2.355060711 |
| Sum | 18496 |
| Variance | 29328.04995 |
| Value | Count | Frequency (%) | |
| 102 | 13 | 11.9% | |
| 85 | 12 | 11.0% | |
| 34 | 8 | 7.3% | |
| 170 | 7 | 6.4% | |
| 51 | 6 | 5.5% | |
| 187 | 5 | 4.6% | |
| 17 | 5 | 4.6% | |
| 153 | 5 | 4.6% | |
| 68 | 5 | 4.6% | |
| 0 | 5 | 4.6% | |
| Other values (19) | 38 | 34.9% |
| Value | Count | Frequency (%) | |
| 0 | 5 | 4.6% | |
| 17 | 5 | 4.6% | |
| 34 | 8 | 7.3% | |
| 51 | 6 | 5.5% | |
| 68 | 5 | 4.6% |
| Value | Count | Frequency (%) | |
| 935 | 1 | 0.9% | |
| 816 | 1 | 0.9% | |
| 765 | 1 | 0.9% | |
| 748 | 1 | 0.9% | |
| 612 | 1 | 0.9% |
| Distinct count | 1 |
|---|---|
| Unique (%) | 0.9% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 109.0 B |
| 1 |
|---|
| Value | Count | Frequency (%) | |
| 1 | 109 | 100.0% |
| Distinct count | 2 |
|---|---|
| Unique (%) | 1.8% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 109.0 B |
| 0 | |
|---|---|
| 1 | 12 |
| Value | Count | Frequency (%) | |
| 0 | 97 | 89.0% | |
| 1 | 12 | 11.0% |
| Distinct count | 2 |
|---|---|
| Unique (%) | 1.8% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 109.0 B |
| 1 | |
|---|---|
| 0 | 12 |
| Value | Count | Frequency (%) | |
| 1 | 97 | 89.0% | |
| 0 | 12 | 11.0% |
Data Vertical_Auto Loan
Boolean
| Distinct count | 2 |
|---|---|
| Unique (%) | 1.8% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 109.0 B |
| 0 | |
|---|---|
| 1 | 1 |
| Value | Count | Frequency (%) | |
| 0 | 108 | 99.1% | |
| 1 | 1 | 0.9% |
Data Vertical_Credit
Boolean
| Distinct count | 2 |
|---|---|
| Unique (%) | 1.8% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 109.0 B |
| 0 | |
|---|---|
| 1 |
| Value | Count | Frequency (%) | |
| 0 | 70 | 64.2% | |
| 1 | 39 | 35.8% |
Data Vertical_FHA
Boolean
| Distinct count | 2 |
|---|---|
| Unique (%) | 1.8% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 109.0 B |
| 0 | |
|---|---|
| 1 | 7 |
| Value | Count | Frequency (%) | |
| 0 | 102 | 93.6% | |
| 1 | 7 | 6.4% |
Data Vertical_Grants
Boolean
| Distinct count | 2 |
|---|---|
| Unique (%) | 1.8% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 109.0 B |
| 0 | |
|---|---|
| 1 | 3 |
| Value | Count | Frequency (%) | |
| 0 | 106 | 97.2% | |
| 1 | 3 | 2.8% |
Data Vertical_Internal
Boolean
| Distinct count | 2 |
|---|---|
| Unique (%) | 1.8% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 109.0 B |
| 0 | |
|---|---|
| 1 | 5 |
| Value | Count | Frequency (%) | |
| 0 | 104 | 95.4% | |
| 1 | 5 | 4.6% |
Data Vertical_Paleo
Boolean
| Distinct count | 2 |
|---|---|
| Unique (%) | 1.8% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 109.0 B |
| 0 | |
|---|---|
| 1 | 1 |
| Value | Count | Frequency (%) | |
| 0 | 108 | 99.1% | |
| 1 | 1 | 0.9% |
Data Vertical_Personal Loan
Boolean
| Distinct count | 2 |
|---|---|
| Unique (%) | 1.8% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 109.0 B |
| 0 | |
|---|---|
| 1 |
| Value | Count | Frequency (%) | |
| 0 | 67 | 61.5% | |
| 1 | 42 | 38.5% |
Data Vertical_Refinance
Boolean
| Distinct count | 2 |
|---|---|
| Unique (%) | 1.8% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 109.0 B |
| 0 | |
|---|---|
| 1 | 2 |
| Value | Count | Frequency (%) | |
| 0 | 107 | 98.2% | |
| 1 | 2 | 1.8% |
Data Vertical_Rent To Own
Boolean
| Distinct count | 2 |
|---|---|
| Unique (%) | 1.8% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 109.0 B |
| 0 | |
|---|---|
| 1 | 9 |
| Value | Count | Frequency (%) | |
| 0 | 100 | 91.7% | |
| 1 | 9 | 8.3% |
Offer Name1_First Access Solid Black Visa Credit Card - Display - Lead Submit - W4 (e-mail)
Boolean
CONSTANTREJECTED| Distinct count | 1 |
|---|---|
| Unique (%) | 0.9% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 109.0 B |
| 1 |
|---|
| Value | Count | Frequency (%) | |
| 1 | 109 | 100.0% |
| Distinct count | 1 |
|---|---|
| Unique (%) | 0.9% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 109.0 B |
| 1 |
|---|
| Value | Count | Frequency (%) | |
| 1 | 109 | 100.0% |
| Distinct count | 1 |
|---|---|
| Unique (%) | 0.9% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 109.0 B |
| 1 |
|---|
| Value | Count | Frequency (%) | |
| 1 | 109 | 100.0% |
Segment1_A14
Boolean
| Distinct count | 2 |
|---|---|
| Unique (%) | 1.8% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 109.0 B |
| 0 | |
|---|---|
| 1 | 1 |
| Value | Count | Frequency (%) | |
| 0 | 108 | 99.1% | |
| 1 | 1 | 0.9% |
Segment1_A21
Boolean
| Distinct count | 2 |
|---|---|
| Unique (%) | 1.8% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 109.0 B |
| 0 | |
|---|---|
| 1 | 3 |
| Value | Count | Frequency (%) | |
| 0 | 106 | 97.2% | |
| 1 | 3 | 2.8% |
Segment1_MI
Boolean
| Distinct count | 2 |
|---|---|
| Unique (%) | 1.8% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 109.0 B |
| 0 | |
|---|---|
| 1 | 6 |
| Value | Count | Frequency (%) | |
| 0 | 103 | 94.5% | |
| 1 | 6 | 5.5% |
Segment1_O1
Boolean
| Distinct count | 2 |
|---|---|
| Unique (%) | 1.8% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 109.0 B |
| 0 | |
|---|---|
| 1 | 2 |
| Value | Count | Frequency (%) | |
| 0 | 107 | 98.2% | |
| 1 | 2 | 1.8% |
Segment1_O14
Boolean
| Distinct count | 2 |
|---|---|
| Unique (%) | 1.8% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 109.0 B |
| 0 | |
|---|---|
| 1 | 8 |
| Value | Count | Frequency (%) | |
| 0 | 101 | 92.7% | |
| 1 | 8 | 7.3% |
Segment1_O21
Boolean
| Distinct count | 2 |
|---|---|
| Unique (%) | 1.8% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 109.0 B |
| 0 | |
|---|---|
| 1 | 15 |
| Value | Count | Frequency (%) | |
| 0 | 94 | 86.2% | |
| 1 | 15 | 13.8% |
Segment1_O30
Boolean
| Distinct count | 2 |
|---|---|
| Unique (%) | 1.8% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 109.0 B |
| 1 | |
|---|---|
| 0 |
| Value | Count | Frequency (%) | |
| 1 | 74 | 67.9% | |
| 0 | 35 | 32.1% |
Pearson's r
The Pearson's correlation coefficient (r) is a measure of linear correlation between two variables. It's value lies between -1 and +1, -1 indicating total negative linear correlation, 0 indicating no linear correlation and 1 indicating total positive linear correlation. Furthermore, r is invariant under separate changes in location and scale of the two variables, implying that for a linear function the angle to the x-axis does not affect r.To calculate r for two variables X and Y, one divides the covariance of X and Y by the product of their standard deviations.
Spearman's ρ
The Spearman's rank correlation coefficient (ρ) is a measure of monotonic correlation between two variables, and is therefore better in catching nonlinear monotonic correlations than Pearson's r. It's value lies between -1 and +1, -1 indicating total negative monotonic correlation, 0 indicating no monotonic correlation and 1 indicating total positive monotonic correlation.To calculate ρ for two variables X and Y, one divides the covariance of the rank variables of X and Y by the product of their standard deviations.
Kendall's τ
Similarly to Spearman's rank correlation coefficient, the Kendall rank correlation coefficient (τ) measures ordinal association between two variables. It's value lies between -1 and +1, -1 indicating total negative correlation, 0 indicating no correlation and 1 indicating total positive correlation.To calculate τ for two variables X and Y, one determines the number of concordant and discordant pairs of observations. τ is given by the number of concordant pairs minus the discordant pairs divided by the total number of pairs.
Phik (φk)
Phik (φk) is a new and practical correlation coefficient that works consistently between categorical, ordinal and interval variables, captures non-linear dependency and reverts to the Pearson correlation coefficient in case of a bivariate normal input distribution. There is extensive documentation available here.First rows
| Affiliate ID1 | eCPM | CTR | EPC | CLR | # Drops | Click Rate | Clicks | Date1 | Delivered | Offer ID1 | Open Rate | Opens | Remaining Budget | Revenue | Name_First Access Solid B | Data Provider (group)_Irvine | Data Provider (group)_Venice | Data Vertical_Auto Loan | Data Vertical_Credit | Data Vertical_FHA | Data Vertical_Grants | Data Vertical_Internal | Data Vertical_Paleo | Data Vertical_Personal Loan | Data Vertical_Refinance | Data Vertical_Rent To Own | Offer Name1_First Access Solid Black Visa Credit Card - Display - Lead Submit - W4 (e-mail) | Operational Status1_Live | Payout Type1_1st PAGE SUBMIT | Segment1_A14 | Segment1_A21 | Segment1_MI | Segment1_O1 | Segment1_O14 | Segment1_O21 | Segment1_O30 | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 0 | 460639 | 5.48 | 0.0193 | 0.28 | 0.0 | 1 | 0.1042 | 777 | 2020-03-02 | 40318 | 4915 | 0.185 | 7458 | 0 | 221 | 1 | 0 | 1 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 |
| 1 | 460804 | 4.02 | 0.0196 | 0.21 | 0.0 | 1 | 0.1210 | 1240 | 2020-04-09 | 63419 | 4915 | 0.161 | 10231 | 0 | 255 | 1 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 1 | 1 | 1 | 0 | 0 | 0 | 0 | 1 | 0 | 0 |
| 2 | 460639 | 11.41 | 0.0413 | 0.28 | 0.0 | 1 | 0.1260 | 615 | 2020-03-13 | 14899 | 4915 | 0.327 | 4874 | 0 | 170 | 1 | 0 | 1 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 1 | 1 | 0 | 0 | 0 | 1 | 0 | 0 | 0 |
| 3 | 460639 | 8.23 | 0.0456 | 0.18 | 0.0 | 1 | 0.1460 | 659 | 2020-03-27 | 14451 | 4915 | 0.313 | 4518 | 0 | 119 | 1 | 0 | 1 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 1 | 1 | 0 | 0 | 0 | 1 | 0 | 0 | 0 |
| 4 | 460804 | 12.58 | 0.0265 | 0.47 | 0.0 | 1 | 0.1210 | 1971 | 2020-03-22 | 74337 | 4915 | 0.219 | 16314 | 0 | 935 | 1 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 1 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 1 | 0 |
| 5 | 460804 | 11.76 | 0.0263 | 0.45 | 0.0 | 1 | 0.1630 | 1827 | 2020-03-12 | 69408 | 4915 | 0.161 | 11185 | 0 | 816 | 1 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 1 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 1 | 0 |
| 6 | 460467 | 11.25 | 0.0240 | 0.47 | 0.0 | 1 | 0.0840 | 1630 | 2020-03-10 | 67988 | 4915 | 0.286 | 19429 | 0 | 765 | 1 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 1 | 1 | 1 | 0 | 0 | 0 | 0 | 1 | 0 | 0 |
| 7 | 460467 | 1.56 | 0.0067 | 0.23 | 0.0 | 1 | 0.0570 | 363 | 2020-03-20 | 54576 | 4915 | 0.117 | 6393 | 0 | 85 | 1 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 1 | 1 | 1 | 0 | 0 | 0 | 0 | 1 | 0 | 0 |
| 8 | 460467 | 2.24 | 0.0067 | 0.33 | 0.0 | 1 | 0.0660 | 408 | 2020-04-09 | 60720 | 4915 | 0.101 | 6157 | 0 | 136 | 1 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 1 | 1 | 1 | 0 | 0 | 0 | 0 | 1 | 0 | 0 |
| 9 | 460639 | 3.73 | 0.0160 | 0.23 | 0.0 | 1 | 0.1050 | 730 | 2020-04-08 | 45622 | 4915 | 0.153 | 6980 | 0 | 170 | 1 | 0 | 1 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 |
Last rows
| Affiliate ID1 | eCPM | CTR | EPC | CLR | # Drops | Click Rate | Clicks | Date1 | Delivered | Offer ID1 | Open Rate | Opens | Remaining Budget | Revenue | Name_First Access Solid B | Data Provider (group)_Irvine | Data Provider (group)_Venice | Data Vertical_Auto Loan | Data Vertical_Credit | Data Vertical_FHA | Data Vertical_Grants | Data Vertical_Internal | Data Vertical_Paleo | Data Vertical_Personal Loan | Data Vertical_Refinance | Data Vertical_Rent To Own | Offer Name1_First Access Solid Black Visa Credit Card - Display - Lead Submit - W4 (e-mail) | Operational Status1_Live | Payout Type1_1st PAGE SUBMIT | Segment1_A14 | Segment1_A21 | Segment1_MI | Segment1_O1 | Segment1_O14 | Segment1_O21 | Segment1_O30 | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 99 | 460750 | 2.68 | 0.0112 | 0.24 | 0.0033 | 1 | 0.0860 | 497 | 2020-04-01 | 44347 | 4915 | 0.1310 | 5807 | 0 | 119 | 1 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 1 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 |
| 100 | 460351 | 10.48 | 0.0314 | 0.33 | 0.0016 | 1 | 0.1146 | 1325 | 2020-02-11 | 42171 | 4915 | 0.2741 | 11557 | 0 | 442 | 1 | 0 | 1 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 |
| 101 | 460351 | 5.35 | 0.0169 | 0.32 | 0.0006 | 1 | 0.0801 | 646 | 2020-02-23 | 38125 | 4915 | 0.2116 | 8069 | 0 | 204 | 1 | 0 | 1 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 |
| 102 | 460483 | 2.06 | 0.0089 | 0.23 | 0.0000 | 1 | 0.0559 | 294 | 2020-02-27 | 33070 | 4915 | 0.1591 | 5262 | 0 | 68 | 1 | 0 | 1 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 |
| 103 | 460639 | 0.40 | 0.0107 | 0.04 | 0.0000 | 1 | 0.1312 | 458 | 2020-02-03 | 42956 | 4915 | 0.0812 | 3490 | 0 | 17 | 1 | 0 | 1 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 |
| 104 | 460724 | 3.82 | 0.0108 | 0.35 | 0.0000 | 1 | 0.0798 | 289 | 2020-02-07 | 26722 | 4915 | 0.1355 | 3622 | 0 | 102 | 1 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 1 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 |
| 105 | 460724 | 1.17 | 0.0129 | 0.09 | 0.0000 | 1 | 0.0814 | 374 | 2020-02-29 | 28976 | 4915 | 0.1586 | 4595 | 0 | 34 | 1 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 1 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 |
| 106 | 460743 | 7.52 | 0.0115 | 0.66 | 0.0000 | 1 | 0.0830 | 389 | 2020-02-23 | 33905 | 4915 | 0.1383 | 4689 | 0 | 255 | 1 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 1 | 1 | 1 | 0 | 0 | 0 | 0 | 1 | 0 | 0 |
| 107 | 460743 | 4.54 | 0.0141 | 0.32 | 0.0000 | 1 | 0.0818 | 476 | 2020-02-29 | 33672 | 4915 | 0.1727 | 5816 | 0 | 153 | 1 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 1 | 1 | 1 | 0 | 0 | 0 | 0 | 1 | 0 | 0 |
| 108 | 460743 | 9.46 | 0.0232 | 0.41 | 0.0000 | 1 | 0.1292 | 875 | 2020-02-16 | 37733 | 4915 | 0.1794 | 6771 | 0 | 357 | 1 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 1 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 |